What happend to odbc.sql & odbc-drop.sql

I am attempting to use the directions at
http://kandalaya.org//download/oo-pgsql.html
to configure odbc with pgsql and OpenOffice.org on a Fedora Core 4 system.

I found a message at:
http://archives.postgresql.org/pgsql-odbc/2003-09/msg00087.p hp
which points to the psqlodbc cvs, but that appears empty.

And when I got psqlodbc-08.01.0100.tar.gz (that is the correct one to use with
postgresql-8.0.6 right?) and looked in it, there was no mention of the
odbc.sql & odbc-drop.sql scripts, or even what should replace them.

So is there a reason why these went away?
What should they be replaced with?
Or should I just dig out an old copy of postgresql-7.X and grab them from
there for posterity?

--
Todd Denniston
Crane Division, Naval Surface Warfare Center (NSWC Crane)
Harnessing the Power of Technology for the Warfighter

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: What happend to odbc.sql & odbc-drop.sql

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston
> Sent: 13 February 2006 15:58
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] What happend to odbc.sql & odbc-drop.sql
>=20
> I am attempting to use the directions at
> http://kandalaya.org//download/oo-pgsql.html
> to configure odbc with pgsql and OpenOffice.org on a Fedora=20
> Core 4 system.
>=20
> I found a message at:
> http://archives.postgresql.org/pgsql-odbc/2003-09/msg00087.p hp
> which points to the psqlodbc cvs, but that appears empty.
>=20
> And when I got psqlodbc-08.01.0100.tar.gz (that is the=20
> correct one to use with=20
> postgresql-8.0.6 right?) and looked in it, there was no=20
> mention of the=20
> odbc.sql & odbc-drop.sql scripts, or even what should replace them.
>=20
> So is there a reason why these went away?
> What should they be replaced with?
> Or should I just dig out an old copy of postgresql-7.X and=20
> grab them from=20
> there for posterity?

It was removed because it is no longer required:

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodb c/convert.c?
rev=3D1.117&content-type=3Dtext/x-cvsweb-markup

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: What happend to odbc.sql & odbc-drop.sql

> And when I got psqlodbc-08.01.0100.tar.gz (that is the correct one to use

The psqlodbc-08.01.0200 is the most up to date stable release.
This version (08.01.XXXX has some limitations which older drivers doesn't
have (older = 08.00 and older).

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: What happend to odbc.sql & odbc-drop.sql

This is a multi-part message in MIME format.
--------------050102010200020606020108
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: pgsql-odbc-owner@postgresql.org
>>[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston
>>Sent: 13 February 2006 15:58
>>To: pgsql-odbc@postgresql.org
>>Subject: [ODBC] What happend to odbc.sql & odbc-drop.sql
>>
>>I am attempting to use the directions at
>>http://kandalaya.org//download/oo-pgsql.html
>>to configure odbc with pgsql and OpenOffice.org on a Fedora
>>Core 4 system.
>>
>>I found a message at:
>>http://archives.postgresql.org/pgsql-odbc/2003-09/msg00087 .php
>>which points to the psqlodbc cvs, but that appears empty.
>>
...
>>there was no
>>mention of the
>>odbc.sql & odbc-drop.sql scripts, or even what should replace them.
>>
>>So is there a reason why these went away?

>
>
> It was removed because it is no longer required:
>
> http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodb c/convert.c?rev=1.117&content-type=text/x-cvsweb-markup
>
> Regards, Dave.
>

So with postgresql-8.0.6 and postgresql-odbc-08.00.0100 as installed by
Fedora, I should be able to just skip section 5.1 of the kandalaya document then?

It might be good to add that little tidbit to your faq.html {patch attached,
but needs spell checked}.

and on the subscription page, the link to the FAQ seems broken too.
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.or g&func=lists-long-full&extra=pgsql-odbc

Thanks for the update.
--
Todd Denniston
Crane Division, Naval Surface Warfare Center (NSWC Crane)
Harnessing the Power of Technology for the Warfighter

--------------050102010200020606020108
Content-Type: text/x-patch;
name="faq.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="faq.patch"

--- docs/faq.html.orig 2006-02-13 18:31:15.000000000 -0500
+++ docs/faq.html 2006-02-13 18:43:01.000000000 -0500
@@ -16,3 +16,3 @@

The most recent version of this document can be viewed at - "http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/~checkout~/p sqlodbc/docs/faq.html?content-type=text%2Fhtml;cvsroot=psqlo dbc">http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/~checkou t~/psqlodbc/docs/faq.html?content-type=text%2Fhtml;cvsroot=p sqlodbc.

) What happend to odbc.sql & odbc-drop.sql?

+ Functionality in convert.c removed the need for them. You can safely skip over any steps
+ in old procedures that called for these scripts.
+

4) Advanced

Re: What happend to odbc.sql & odbc-drop.sql

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston
> Sent: 13 February 2006 23:47
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] What happend to odbc.sql & odbc-drop.sql
>=20
>=20
> So with postgresql-8.0.6 and postgresql-odbc-08.00.0100 as=20
> installed by=20
> Fedora, I should be able to just skip section 5.1 of the=20
> kandalaya document then?

I would guess so, but I have no knowledge of that document.

> It might be good to add that little tidbit to your faq.html=20
> {patch attached,=20
> but needs spell checked}.

Thanks, but as you're the first person I recall to ever ask that
question, I don't think it really counts as a faq :-) An update to the
kandalaya document would seem more appropriate.

> and on the subscription page, the link to the FAQ seems broken too.
> http://mail.postgresql.org/mj/mj_wwwusr?domain=3Dpostgresql. org&
> func=3Dlists-long-full&extra=3Dpgsql-odbc

No, that's maintained by Majordomo, the mailer software. I'm not sure if
we can change that - I'll ask the admin.

Thanks, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly